|
 |
 |
To access the contents, click the chapter and section titles.
Oracle Performance Tuning and Optimization
(Publisher: Macmillan Computer Publishing)
Author(s): Edward Whalen
ISBN: 067230886x
Publication Date: 04/01/96
Appendix F Contents of the CD-ROM
This appendix lists the contents of the CD-ROM disc that accompanies this book. Included on the disc are the SQL scripts used to create many of the examples in the book.
SQL Scripts
The following sections give brief descriptions of the SQL scripts used as examples in this book; the scripts are provided on the CD-ROM disc.
Chapter 9
09opt01.sql
| Extract library cache-miss percent.
|
09opt02.sql
| Extract library cache-miss rate.
|
09opt03.sql
| Extract data dictionary area cache-miss percent.
|
09opt04.sql
| Extract data dictionary area cache-miss rate.
|
09opt05.sql
| Extract buffer cache information.
|
09opt06.sql
| Extract physical I/O information.
|
09opt07.sql
| Create striped tablespace.
|
09opt08.sql
| Create table on that tablespace with stripe.
|
09opt09.sql
| Create chained rows table and analyze.
|
09opt11.sql
| Check dynamic rollback segment growth.
|
09opt10.sql
| Check recursive calls.
|
09opt12.sql
| Check rollback segment statistics.
|
09opt13.sql
| Check for rollback segment contention.
|
09opt14.sql
| Check for log buffer contention.
|
09opt15.sql
| Check for latch contention.
|
09opt16.sql
| Check sort performance.
|
09opt17.sql
| Check for free list contention.
|
Chapter 10
10opt01.sql
| Look for tablespace fragmentation.
|
10opt02.sql
| Create DOGS table.
|
10opt03.sql
| Create BREEDS table.
|
10opt04.sql
| Load BREEDS table.
|
10opt05.sql
| Load DOGS table.
|
10opt06.sql
| Create dog_space tablespace.
|
10opt07.sql
| Create dog_cluster.
|
10opt08.sql
| Create DOGS2 table in dog_cluster.
|
10opt09.sql
| Create BREEDS2 table in dog_cluster.
|
10opt10.sql
| Create index on dog_cluster.
|
10opt11.sql
| Load BREEDS2.
|
10opt12.sql
| Load DOGS2.
|
NOTE: The CD-ROM contains two versions of the same tables: DOGS and DOGS2, and BREEDS and BREEDS2. One set of tables has constraints defined within the table; the other set uses alternative table commands.
Chapter 16
16opt01.sql
| Create a striped tablespace.
|
16opt02.sql
| Create a striped table.
|
Chapter 25
25opt01.sql
| Create tablespace dog_space and create tables DOGS and BREEDS.
|
25opt02.sql
| Insert rows into BREEDS table.
|
25opt03.sql
| Insert rows into DOGS table.
|
25opt04.sql
| Select sid, serial# and osuser from V$SESSION.
|
25opt05.sql
| Turn on SQL Trace for session.
|
25opt06.sql
| Turn off SQL Trace for session.
|
25opt07.sql
| Select join from DOGS and BREEDS.
|
25opt08.bat
| Run TKPROF.
|
25opt09.sql
| Create plan_table.
|
25opt10.sql
| EXPLAIN PLAN example.
|
25opt11.sql
| Set up plan_table.
|
25opt12.sql
| Extract execution plan from plan_table.
|
Chapter 27
27opt01.sql
| ANALYZE TABLE with COMPUTE STATISTICS.
|
27opt02.sql
| ANALYZE TABLE with ESTIMATE STATISTICS.
|
27opt03.sql
| ANALYZE TABLE with ESTIMATE STATISTICS with SAMPLE.
|
27opt04.sql
| ANALYZE TABLE with VALIDATE STRUCTURE.
|
27opt05.sql
| ANALYZE TABLE with LIST CHAINED ROWS INTO.
|
27opt06.sql
| ANALYZE TABLE with LIST CHAINED ROWS.
|
Chapter 28
28opt01.sql
| Create stored procedure old_dogs.
|
Chapter 29
29opt01.txt
| DOGS table in Wordpad format.
|
29opt02.txt
| BREEDS table in Wordpad format.
|
29opt03.sql
| ALTER TABLE BREEDS to ADD PRIMARY KEY(breed).
|
29opt04.sql
| ALTER TABLE DOGS to ADD FOREIGN KEY BREEDS(breed).
|
29opt05.sql
| ALTER TABLE DOGS for CHECK.
|
29opt06.sql
| Add dog that fails constraint.
|
29opt07.sql
| Add dog that passes constraint.
|
29opt08.sql
| CREATE TABLE DOGS and BREEDS with constraints.
|
29opt09.sql
| Select constraint information.
|
29opt10.sql
| Select constraint information for DOGS table.
|
29opt11.sql
| Select column constraint information.
|
29opt12.sql
| Add trigger, old_one.
|
29opt13.sql
| Add an old dog.
|
Chapter 32
32opt01.sql
| CREATE SEQUENCE.
|
32opt02.sql
| Use the sequence.
|
32opt03.sql
| Demonstrate array processing.
|
|